﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace DTcms.Core.DBFactory.Migrations
{
    public partial class initDatabase : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "dt_areas",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ParentId = table.Column<int>(type: "INTEGER", nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_areas", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_category",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    ChannelId = table.Column<int>(type: "INTEGER", nullable: false),
                    ParentId = table.Column<long>(type: "INTEGER", nullable: false),
                    CallIndex = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    ImgUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    LinkUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Content = table.Column<string>(type: "TEXT", maxLength: 1024, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    SeoTitle = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SeoKeyword = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SeoDescription = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    UpdateBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_category", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_label",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    UpdateBy = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_label", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_manager_log",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserName = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Method = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Path = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Query = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    StatusCode = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_manager_log", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_manager_menu",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ParentId = table.Column<int>(type: "INTEGER", nullable: false),
                    ChannelId = table.Column<int>(type: "INTEGER", nullable: false),
                    Name = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    SubTitle = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    IconUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    LinkUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsSystem = table.Column<byte>(type: "INTEGER", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Controller = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Resource = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_manager_menu", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_manager_menu_model",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ParentId = table.Column<int>(type: "INTEGER", nullable: false),
                    NavType = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Name = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    SubTitle = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    IconUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    LinkUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Controller = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Resource = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_manager_menu_model", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_member_address",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    AcceptName = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Province = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    City = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Area = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Address = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Telphone = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Mobile = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Zip = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    IsDefault = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_member_address", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_member_amount_log",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    Value = table.Column<decimal>(type: "decimal(18, 2)", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_member_amount_log", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_member_group",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    MinExp = table.Column<int>(type: "INTEGER", nullable: false),
                    MaxExp = table.Column<int>(type: "INTEGER", nullable: false),
                    Amount = table.Column<decimal>(type: "decimal(18, 2)", nullable: false),
                    Discount = table.Column<int>(type: "INTEGER", nullable: false),
                    IsUpgrade = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsDefault = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    UpdateBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_member_group", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_member_message",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Content = table.Column<string>(type: "text", nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    IsRead = table.Column<byte>(type: "INTEGER", nullable: false),
                    ReadTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_member_message", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_member_point_log",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    Value = table.Column<int>(type: "INTEGER", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_member_point_log", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_notify_template",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Type = table.Column<byte>(type: "INTEGER", nullable: false),
                    CallIndex = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Content = table.Column<string>(type: "text", nullable: true),
                    IsSystem = table.Column<byte>(type: "INTEGER", nullable: false),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_notify_template", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_payments",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    ImgUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Remark = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Type = table.Column<byte>(type: "INTEGER", nullable: false),
                    PayUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    NotifyUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_payments", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_roles",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    RoleType = table.Column<byte>(type: "INTEGER", nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    IsSystem = table.Column<byte>(type: "INTEGER", nullable: false),
                    Name = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
                    NormalizedName = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
                    ConcurrencyStamp = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_roles", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_sites",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Name = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    DirPath = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Logo = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Company = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Address = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Tel = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Fax = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Email = table.Column<string>(type: "TEXT", maxLength: 60, nullable: true),
                    Crod = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Copyright = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SeoTitle = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SeoKeyword = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SeoDescription = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    IsDefault = table.Column<byte>(type: "INTEGER", nullable: false),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_sites", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_sysconfig",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Type = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    JsonData = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_sysconfig", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_users",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    RefreshToken = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    UserName = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
                    NormalizedUserName = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
                    Email = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
                    NormalizedEmail = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true),
                    EmailConfirmed = table.Column<bool>(type: "INTEGER", nullable: false),
                    PasswordHash = table.Column<string>(type: "TEXT", nullable: true),
                    SecurityStamp = table.Column<string>(type: "TEXT", nullable: true),
                    ConcurrencyStamp = table.Column<string>(type: "TEXT", nullable: true),
                    PhoneNumber = table.Column<string>(type: "TEXT", nullable: true),
                    PhoneNumberConfirmed = table.Column<bool>(type: "INTEGER", nullable: false),
                    TwoFactorEnabled = table.Column<bool>(type: "INTEGER", nullable: false),
                    LockoutEnd = table.Column<DateTimeOffset>(type: "TEXT", nullable: true),
                    LockoutEnabled = table.Column<bool>(type: "INTEGER", nullable: false),
                    AccessFailedCount = table.Column<int>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_users", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "dt_role_claims",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    RoleId = table.Column<int>(type: "INTEGER", nullable: false),
                    ClaimType = table.Column<string>(type: "TEXT", nullable: true),
                    ClaimValue = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_role_claims", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_role_claims_dt_roles_RoleId",
                        column: x => x.RoleId,
                        principalTable: "dt_roles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_site_channel",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    Name = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    IsComment = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsAlbum = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsAttach = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsContribute = table.Column<byte>(type: "INTEGER", nullable: false),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_site_channel", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_site_channel_dt_sites_SiteId",
                        column: x => x.SiteId,
                        principalTable: "dt_sites",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_site_domain",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    Domain = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Remark = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_site_domain", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_site_domain_dt_sites_SiteId",
                        column: x => x.SiteId,
                        principalTable: "dt_sites",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_site_payment",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    PaymentId = table.Column<int>(type: "INTEGER", nullable: false),
                    Type = table.Column<string>(type: "TEXT", maxLength: 30, nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Key1 = table.Column<string>(type: "TEXT", nullable: true),
                    Key2 = table.Column<string>(type: "TEXT", nullable: true),
                    Key3 = table.Column<string>(type: "TEXT", nullable: true),
                    Key4 = table.Column<string>(type: "TEXT", nullable: true),
                    Key5 = table.Column<string>(type: "TEXT", nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", maxLength: 1024, nullable: false),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_site_payment", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_site_payment_dt_payments_PaymentId",
                        column: x => x.PaymentId,
                        principalTable: "dt_payments",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_dt_site_payment_dt_sites_SiteId",
                        column: x => x.SiteId,
                        principalTable: "dt_sites",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_manager",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    Avatar = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    RealName = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    IsAudit = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    LastIp = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    LastTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_manager", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_manager_dt_users_UserId",
                        column: x => x.UserId,
                        principalTable: "dt_users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_members",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    GroupId = table.Column<int>(type: "INTEGER", nullable: false),
                    Avatar = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    RealName = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Sex = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    Birthday = table.Column<DateTime>(type: "TEXT", nullable: true),
                    Amount = table.Column<decimal>(type: "decimal(18, 2)", nullable: false),
                    Point = table.Column<int>(type: "INTEGER", nullable: false),
                    Exp = table.Column<int>(type: "INTEGER", nullable: false),
                    RegIp = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    RegTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    LastIp = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    LastTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_members", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_members_dt_member_group_GroupId",
                        column: x => x.GroupId,
                        principalTable: "dt_member_group",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_dt_members_dt_users_UserId",
                        column: x => x.UserId,
                        principalTable: "dt_users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_user_claims",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    ClaimType = table.Column<string>(type: "TEXT", nullable: true),
                    ClaimValue = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_user_claims", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_user_claims_dt_users_UserId",
                        column: x => x.UserId,
                        principalTable: "dt_users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_user_logins",
                columns: table => new
                {
                    LoginProvider = table.Column<string>(type: "TEXT", nullable: false),
                    ProviderKey = table.Column<string>(type: "TEXT", nullable: false),
                    ProviderDisplayName = table.Column<string>(type: "TEXT", nullable: true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_user_logins", x => new { x.LoginProvider, x.ProviderKey });
                    table.ForeignKey(
                        name: "FK_dt_user_logins_dt_users_UserId",
                        column: x => x.UserId,
                        principalTable: "dt_users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_user_roles",
                columns: table => new
                {
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    RoleId = table.Column<int>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_user_roles", x => new { x.UserId, x.RoleId });
                    table.ForeignKey(
                        name: "FK_dt_user_roles_dt_roles_RoleId",
                        column: x => x.RoleId,
                        principalTable: "dt_roles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_dt_user_roles_dt_users_UserId",
                        column: x => x.UserId,
                        principalTable: "dt_users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_user_tokens",
                columns: table => new
                {
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    LoginProvider = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Value = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_user_tokens", x => new { x.UserId, x.LoginProvider, x.Name });
                    table.ForeignKey(
                        name: "FK_dt_user_tokens_dt_users_UserId",
                        column: x => x.UserId,
                        principalTable: "dt_users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_contribute",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    ChannelId = table.Column<int>(type: "INTEGER", nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 512, nullable: false),
                    Source = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Author = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    ImgUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    FieldMeta = table.Column<string>(type: "TEXT", nullable: true),
                    AlbumMeta = table.Column<string>(type: "TEXT", nullable: true),
                    AttachMeta = table.Column<string>(type: "TEXT", nullable: true),
                    Content = table.Column<string>(type: "text", nullable: true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    UserName = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    UpdateBy = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_contribute", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_contribute_dt_site_channel_ChannelId",
                        column: x => x.ChannelId,
                        principalTable: "dt_site_channel",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_articles",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    ChannelId = table.Column<int>(type: "INTEGER", nullable: false),
                    CallIndex = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Title = table.Column<string>(type: "TEXT", maxLength: 512, nullable: false),
                    Source = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Author = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    LinkUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    ImgUrl = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SeoTitle = table.Column<string>(type: "TEXT", maxLength: 255, nullable: true),
                    SeoKeyword = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SeoDescription = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Zhaiyao = table.Column<string>(type: "TEXT", maxLength: 255, nullable: true),
                    Content = table.Column<string>(type: "text", nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    Click = table.Column<int>(type: "INTEGER", nullable: false),
                    GroupIds = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsComment = table.Column<byte>(type: "INTEGER", nullable: false),
                    CommentCount = table.Column<int>(type: "INTEGER", nullable: false),
                    LikeCount = table.Column<int>(type: "INTEGER", nullable: false),
                    AddBy = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    UpdateBy = table.Column<string>(type: "TEXT", maxLength: 30, nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_articles", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_articles_dt_site_channel_ChannelId",
                        column: x => x.ChannelId,
                        principalTable: "dt_site_channel",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_site_channel_field",
                columns: table => new
                {
                    Id = table.Column<int>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ChannelId = table.Column<int>(type: "INTEGER", nullable: false),
                    Name = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    Title = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    ControlType = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    ItemOption = table.Column<string>(type: "TEXT", nullable: true),
                    DefaultValue = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    IsPassword = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsRequired = table.Column<byte>(type: "INTEGER", nullable: false),
                    EditorType = table.Column<byte>(type: "INTEGER", nullable: false),
                    ValidTipMsg = table.Column<string>(type: "TEXT", maxLength: 255, nullable: true),
                    ValidErrorMsg = table.Column<string>(type: "TEXT", maxLength: 255, nullable: true),
                    ValidPattern = table.Column<string>(type: "TEXT", maxLength: 255, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_site_channel_field", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_site_channel_field_dt_site_channel_ChannelId",
                        column: x => x.ChannelId,
                        principalTable: "dt_site_channel",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_payment_collection",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    TradeNo = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false),
                    TradeType = table.Column<byte>(type: "INTEGER", nullable: false),
                    PaymentId = table.Column<int>(type: "INTEGER", nullable: false),
                    PaymentType = table.Column<byte>(type: "INTEGER", nullable: false),
                    PaymentTitle = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    PaymentAmount = table.Column<decimal>(type: "decimal(18, 2)", nullable: false),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    StartTime = table.Column<DateTime>(type: "TEXT", nullable: false),
                    EndTime = table.Column<DateTime>(type: "TEXT", nullable: true),
                    CompleteTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_payment_collection", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_payment_collection_dt_site_payment_PaymentId",
                        column: x => x.PaymentId,
                        principalTable: "dt_site_payment",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_album",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ArticleId = table.Column<long>(type: "INTEGER", nullable: false),
                    ThumbPath = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    OriginalPath = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    Remark = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_album", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_album_dt_articles_ArticleId",
                        column: x => x.ArticleId,
                        principalTable: "dt_articles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_attach",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ArticleId = table.Column<long>(type: "INTEGER", nullable: false),
                    FileName = table.Column<string>(type: "TEXT", maxLength: 255, nullable: true),
                    FilePath = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    FileSize = table.Column<int>(type: "INTEGER", nullable: false),
                    FileExt = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Point = table.Column<int>(type: "INTEGER", nullable: false),
                    DownCount = table.Column<int>(type: "INTEGER", nullable: false),
                    SortId = table.Column<int>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_attach", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_attach_dt_articles_ArticleId",
                        column: x => x.ArticleId,
                        principalTable: "dt_articles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_category_relation",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ArticleId = table.Column<long>(type: "INTEGER", nullable: false),
                    CategoryId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_category_relation", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_category_relation_dt_article_category_CategoryId",
                        column: x => x.CategoryId,
                        principalTable: "dt_article_category",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_dt_article_category_relation_dt_articles_ArticleId",
                        column: x => x.ArticleId,
                        principalTable: "dt_articles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_comment",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SiteId = table.Column<int>(type: "INTEGER", nullable: false),
                    ChannelId = table.Column<int>(type: "INTEGER", nullable: false),
                    ArticleId = table.Column<long>(type: "INTEGER", nullable: false),
                    ParentId = table.Column<long>(type: "INTEGER", nullable: false),
                    RootId = table.Column<long>(type: "INTEGER", nullable: false),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    UserName = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    UserIp = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    AtUserId = table.Column<int>(type: "INTEGER", nullable: false),
                    AtUserName = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Content = table.Column<string>(type: "TEXT", maxLength: 512, nullable: true),
                    LikeCount = table.Column<int>(type: "INTEGER", nullable: false),
                    Status = table.Column<byte>(type: "INTEGER", nullable: false),
                    IsDelete = table.Column<byte>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_comment", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_comment_dt_articles_ArticleId",
                        column: x => x.ArticleId,
                        principalTable: "dt_articles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_dt_article_comment_dt_users_UserId",
                        column: x => x.UserId,
                        principalTable: "dt_users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_field_value",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ArticleId = table.Column<long>(type: "INTEGER", nullable: false),
                    FieldId = table.Column<long>(type: "INTEGER", nullable: false),
                    FieldName = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    FieldValue = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_field_value", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_field_value_dt_articles_ArticleId",
                        column: x => x.ArticleId,
                        principalTable: "dt_articles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_label_relation",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ArticleId = table.Column<long>(type: "INTEGER", nullable: false),
                    LabelId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_label_relation", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_label_relation_dt_article_label_LabelId",
                        column: x => x.LabelId,
                        principalTable: "dt_article_label",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_dt_article_label_relation_dt_articles_ArticleId",
                        column: x => x.ArticleId,
                        principalTable: "dt_articles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_like",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ArticleId = table.Column<long>(type: "INTEGER", nullable: false),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_like", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_like_dt_articles_ArticleId",
                        column: x => x.ArticleId,
                        principalTable: "dt_articles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_member_recharge",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    CollectionId = table.Column<long>(type: "INTEGER", nullable: false),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    UserName = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true),
                    Amount = table.Column<decimal>(type: "decimal(18, 2)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_member_recharge", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_member_recharge_dt_payment_collection_CollectionId",
                        column: x => x.CollectionId,
                        principalTable: "dt_payment_collection",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_member_attach_log",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    AttachId = table.Column<long>(type: "INTEGER", nullable: false),
                    FileName = table.Column<string>(type: "TEXT", maxLength: 255, nullable: true),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_member_attach_log", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_member_attach_log_dt_article_attach_AttachId",
                        column: x => x.AttachId,
                        principalTable: "dt_article_attach",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "dt_article_comment_like",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    CommentId = table.Column<long>(type: "INTEGER", nullable: false),
                    UserId = table.Column<int>(type: "INTEGER", nullable: false),
                    AddTime = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_dt_article_comment_like", x => x.Id);
                    table.ForeignKey(
                        name: "FK_dt_article_comment_like_dt_article_comment_CommentId",
                        column: x => x.CommentId,
                        principalTable: "dt_article_comment",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 1, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(3350), 0, "Site", "iconfont icon-home-full", (byte)1, null, "sys_contents", 0, "系统默认导航，请勿更改", "Show", 99, (byte)0, "站点", "站点管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 2, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(3772), 0, "Plugin", "iconfont icon-plugin-full", (byte)1, null, "sys_application", 0, "系统默认导航，请勿更改", "Show", 102, (byte)1, "应用", "应用管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 3, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(3871), 0, "Member", "iconfont icon-user-full", (byte)1, null, "sys_members", 0, "系统默认导航，请勿更改", "Show", 103, (byte)0, "会员", "会员管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 6, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(3968), 0, "Setting", "iconfont icon-setting-full", (byte)0, null, "sys_Controller", 0, "系统默认导航，请勿更改", "Show", 106, (byte)0, "控制面板", "控制面板" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 10, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4062), 0, "Channel", null, (byte)0, null, "site_main", 1, null, "Show", 99, (byte)0, null, "默认站点" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 50, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4137), 0, "Member", null, (byte)0, null, "member_manage", 3, null, "Show", 99, (byte)0, null, "会员管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 51, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4241), 0, "Member", null, (byte)0, "/member/audit", "member_audit", 50, null, "Show,View,Audit", 99, (byte)0, null, "会员审核" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 52, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4315), 0, "Member", null, (byte)0, "/member/list", "member_list", 50, null, "Show,View,Add,Edit,Audit,Delete", 100, (byte)0, null, "会员列表" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 53, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4404), 0, "MemberGroup", null, (byte)0, "/member/group/list", "member_group", 50, null, "Show,View,Add,Edit,Delete", 101, (byte)0, null, "会员组别" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 60, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4466), 0, "Member", null, (byte)0, null, "member_log", 3, null, "Show", 100, (byte)0, null, "会员日志" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 61, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4521), 0, "MemberMessage", null, (byte)0, "/member/message/list", "member_message", 60, null, "Show,View,Add,Delete", 99, (byte)0, null, "站内消息" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 62, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4586), 0, "MemberRecharge", null, (byte)0, "/member/recharge/list", "member_recharge", 60, null, "Show,View,Add,Complete,Delete", 100, (byte)0, null, "充值记录" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 63, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4699), 0, "MemberAmount", null, (byte)0, "/member/amount/list", "member_amount", 60, null, "Show,View,Add,Delete", 101, (byte)0, null, "消费记录" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 64, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4762), 0, "MemberPoint", null, (byte)0, "/member/point/list", "member_point", 60, null, "Show,View,Add,Delete", 102, (byte)0, null, "积分记录" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 70, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4856), 0, "Member", null, (byte)0, null, "member_settings", 3, null, "Show", 101, (byte)0, null, "会员设置" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 71, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(4978), 0, "Setting@MemberConfig", null, (byte)0, "/member/config", "member_config", 70, null, "Show,View,Edit", 99, (byte)0, null, "参数设置" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 72, "admin", new DateTime(2020, 12, 1, 10, 6, 3, 0, DateTimeKind.Unspecified), 0, "NotifyTemplate", null, (byte)0, "/member/template/list", "member_template", 70, null, "Show,View,Add,Edit,Delete", 100, (byte)0, null, "消息模板" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 130, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5345), 0, "Setting", null, (byte)0, null, "sys_settings", 6, null, "Show", 99, (byte)0, null, "系统管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 131, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5406), 0, "Setting@SysConfig", null, (byte)0, "/setting/config", "sys_config", 130, null, "Show,View,Edit", 99, (byte)0, null, "系统设置" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 132, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5470), 0, "Site", null, (byte)0, "/setting/site/list", "sys_site_manage", 130, null, "Show,View,Add,Edit,Delete", 101, (byte)0, null, "站点管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 133, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5529), 0, "Channel", null, (byte)0, "/setting/channel/list", "sys_channel_manage", 130, null, "Show,View,Add,Edit,Delete", 103, (byte)0, null, "频道管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 140, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5588), 0, "Setting", null, (byte)0, null, "sys_module_manage", 6, null, "Show", 101, (byte)0, null, "功能管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 141, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5643), 0, "Area", null, (byte)0, "/setting/area/list", "area_list", 140, null, "Show,View,Add,Edit,Delete", 99, (byte)0, null, "地区管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 142, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5704), 0, "Payment", null, (byte)0, "/setting/payment/list", "payment_list", 140, null, "Show,View,Add,Edit,Delete", 101, (byte)0, null, "支付方式" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 144, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5764), 0, "ManagerMenu", null, (byte)0, "/manager/menu/list", "manager_menu_list", 140, null, "Show,View,Add,Edit,Delete", 105, (byte)0, null, "管理菜单" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 150, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5823), 0, "Manager", null, (byte)0, null, "sys_manager", 6, null, "Show", 103, (byte)0, null, "系统用户" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 151, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(5877), 0, "Manager", null, (byte)0, "/manager/list", "manager_list", 150, null, "Show,View,Add,Edit,Delete", 99, (byte)0, null, "管理员管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 152, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(6018), 0, "ManagerRole", null, (byte)0, "/manager/role/list", "manager_role", 150, null, "Show,View,Add,Edit,Delete", 101, (byte)0, null, "角色管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu",
                columns: new[] { "Id", "AddBy", "AddTime", "ChannelId", "Controller", "IconUrl", "IsSystem", "LinkUrl", "Name", "ParentId", "Remark", "Resource", "SortId", "Status", "SubTitle", "Title" },
                values: new object[] { 153, null, new DateTime(2023, 11, 29, 16, 52, 48, 922, DateTimeKind.Local).AddTicks(6230), 0, "ManagerLog", null, (byte)0, "/manager/log/list", "manager_log", 150, null, "Show,View,Delete", 103, (byte)0, null, "管理日志" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu_model",
                columns: new[] { "Id", "Controller", "IconUrl", "LinkUrl", "Name", "NavType", "ParentId", "Resource", "SortId", "SubTitle", "Title" },
                values: new object[] { 1, "Article", null, null, "manage", "Channel", 0, "Show", 99, null, null });

            migrationBuilder.InsertData(
                table: "dt_manager_menu_model",
                columns: new[] { "Id", "Controller", "IconUrl", "LinkUrl", "Name", "NavType", "ParentId", "Resource", "SortId", "SubTitle", "Title" },
                values: new object[] { 2, "Article", null, "/article/list", "article", "Channel", 1, "Show,View,Add,Edit,Audit,Delete", 99, null, "内容管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu_model",
                columns: new[] { "Id", "Controller", "IconUrl", "LinkUrl", "Name", "NavType", "ParentId", "Resource", "SortId", "SubTitle", "Title" },
                values: new object[] { 3, "ArticleCategory", null, "/article/category/list", "category", "Channel", 1, "Show,View,Add,Edit,Delete", 101, null, "栏目类别" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu_model",
                columns: new[] { "Id", "Controller", "IconUrl", "LinkUrl", "Name", "NavType", "ParentId", "Resource", "SortId", "SubTitle", "Title" },
                values: new object[] { 5, "ArticleLabel", null, "/article/label/list", "label", "Channel", 1, "Show,View,Add,Edit,Delete", 105, null, "标签管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu_model",
                columns: new[] { "Id", "Controller", "IconUrl", "LinkUrl", "Name", "NavType", "ParentId", "Resource", "SortId", "SubTitle", "Title" },
                values: new object[] { 6, "ArticleComment", null, "/article/comment/list", "comment", "Channel", 1, "Show,View,Add,Edit,Delete", 107, null, "评论管理" });

            migrationBuilder.InsertData(
                table: "dt_manager_menu_model",
                columns: new[] { "Id", "Controller", "IconUrl", "LinkUrl", "Name", "NavType", "ParentId", "Resource", "SortId", "SubTitle", "Title" },
                values: new object[] { 7, "ArticleContribute", null, "/article/contribute/list", "contribute", "Channel", 1, "Show,View,Add,Edit,Delete", 109, null, "投稿管理" });

            migrationBuilder.InsertData(
                table: "dt_member_group",
                columns: new[] { "Id", "AddBy", "AddTime", "Amount", "Discount", "IsDefault", "IsUpgrade", "MaxExp", "MinExp", "Title", "UpdateBy", "UpdateTime" },
                values: new object[] { 1, "admin", new DateTime(2023, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), 0m, 100, (byte)1, (byte)1, 1000, 0, "普通会员", null, null });

            migrationBuilder.InsertData(
                table: "dt_notify_template",
                columns: new[] { "Id", "CallIndex", "Content", "IsSystem", "Title", "Type", "UpdateTime" },
                values: new object[] { 1, "usercode", "您本次的验证码为：{code}，{valid}分钟内有效。", (byte)0, "手机验证码", (byte)2, null });

            migrationBuilder.InsertData(
                table: "dt_notify_template",
                columns: new[] { "Id", "CallIndex", "Content", "IsSystem", "Title", "Type", "UpdateTime" },
                values: new object[] { 2, "usercode", "您本次的邮箱验证码为{code}，{valid}分钟内有效。本邮件来自于{webname}，请勿回复！", (byte)0, "您的邮箱验证码", (byte)1, null });

            migrationBuilder.InsertData(
                table: "dt_payments",
                columns: new[] { "Id", "ImgUrl", "NotifyUrl", "PayUrl", "Remark", "SortId", "Status", "Title", "Type" },
                values: new object[] { 1, null, null, null, null, 99, (byte)0, "线下", (byte)0 });

            migrationBuilder.InsertData(
                table: "dt_payments",
                columns: new[] { "Id", "ImgUrl", "NotifyUrl", "PayUrl", "Remark", "SortId", "Status", "Title", "Type" },
                values: new object[] { 2, null, null, "/api/balancepay", "使用预存款扣款", 99, (byte)0, "余额", (byte)1 });

            migrationBuilder.InsertData(
                table: "dt_payments",
                columns: new[] { "Id", "ImgUrl", "NotifyUrl", "PayUrl", "Remark", "SortId", "Status", "Title", "Type" },
                values: new object[] { 3, null, "/api/wechatpay/notify", "/api/wechatpay/", "欢迎使用微信支付", 99, (byte)0, "微信", (byte)2 });

            migrationBuilder.InsertData(
                table: "dt_payments",
                columns: new[] { "Id", "ImgUrl", "NotifyUrl", "PayUrl", "Remark", "SortId", "Status", "Title", "Type" },
                values: new object[] { 4, null, "/api/alipay/notify", "/api/alipay/", "推荐使用支付宝支付", 99, (byte)0, "支付宝", (byte)3 });

            migrationBuilder.InsertData(
                table: "dt_roles",
                columns: new[] { "Id", "ConcurrencyStamp", "IsSystem", "Name", "NormalizedName", "RoleType", "Title" },
                values: new object[] { 1, "32f09a16-6a44-4d3b-8f72-8368ed1e2f9e", (byte)1, "Member", "MEMBER", (byte)0, "普通会员" });

            migrationBuilder.InsertData(
                table: "dt_roles",
                columns: new[] { "Id", "ConcurrencyStamp", "IsSystem", "Name", "NormalizedName", "RoleType", "Title" },
                values: new object[] { 2, "5952e4d7-a5e2-4c82-928d-ac1110c91fdc", (byte)1, "Admin", "ADMIN", (byte)1, "系统管理员" });

            migrationBuilder.InsertData(
                table: "dt_roles",
                columns: new[] { "Id", "ConcurrencyStamp", "IsSystem", "Name", "NormalizedName", "RoleType", "Title" },
                values: new object[] { 3, "501b4cc4-9cf1-4f5a-b1f9-b662a4f582df", (byte)1, "SuperAdmin", "SUPERADMIN", (byte)2, "超级管理员" });

            migrationBuilder.InsertData(
                table: "dt_sites",
                columns: new[] { "Id", "AddBy", "AddTime", "Address", "Company", "Copyright", "Crod", "DirPath", "Email", "Fax", "IsDefault", "Logo", "Name", "SeoDescription", "SeoKeyword", "SeoTitle", "SortId", "Status", "Tel", "Title" },
                values: new object[] { 1, "admin", new DateTime(2020, 12, 1, 9, 30, 54, 0, DateTimeKind.Unspecified), "深圳市宝安区西乡街道九围新村4区217-3幢303室", "深圳市动力启航软件有限公司", "版权所有 © 2009-2023 深圳市动力启航软件有限公司 All Rights Reserved.", "粤ICP备11064298号", "main", "info@dtcms.net", null, (byte)1, null, "default", "让更多的人分享互联网开发技术", "动力启航,DTCMS系统,ASP.NETCore开源,开源CMS,网站管理系统,互联网开发", "DTcms网站管理系统 - 动力启航_开源cms_NetCore开源cms_vue开源cms", 99, (byte)0, "13800138000", "默认站点" });

            migrationBuilder.InsertData(
                table: "dt_sysconfig",
                columns: new[] { "Id", "JsonData", "Type" },
                values: new object[] { 1, "{\"WebName\":\"DTcms内容管理系统\",\"WebCompany\":\"深圳市动力启航软件有限公司\",\"WebAddress\":\"广东省深圳市宝安区西乡街道\"}", "SysConfig" });

            migrationBuilder.InsertData(
                table: "dt_sysconfig",
                columns: new[] { "Id", "JsonData", "Type" },
                values: new object[] { 3, "{\"RegStatus\":0,\"RegVerify\":0,\"RegMsgStatus\":1}", "MemberConfig" });

            migrationBuilder.InsertData(
                table: "dt_users",
                columns: new[] { "Id", "AccessFailedCount", "ConcurrencyStamp", "Email", "EmailConfirmed", "LockoutEnabled", "LockoutEnd", "NormalizedEmail", "NormalizedUserName", "PasswordHash", "PhoneNumber", "PhoneNumberConfirmed", "RefreshToken", "SecurityStamp", "Status", "TwoFactorEnabled", "UserName" },
                values: new object[] { 1, 0, "72420059-828a-4eb1-b27e-3dcf60416724", "info@dtcms.net", false, true, null, "INFO@DTCMS.NET", "ADMIN", "AQAAAAEAACcQAAAAEIIVfBoAbx7EGyOLtH4hZFyeFT819ygZx7ROkladOIfjcsKvMn7PfJCIWApFEtvsSA==", "13800138000", false, null, "XUIGJZRH36KYEUGW3MFUXHQW73OC4C77", (byte)0, false, "admin" });

            migrationBuilder.InsertData(
                table: "dt_manager",
                columns: new[] { "Id", "AddTime", "Avatar", "IsAudit", "LastIp", "LastTime", "RealName", "UserId" },
                values: new object[] { 1, new DateTime(2020, 12, 1, 9, 29, 12, 0, DateTimeKind.Unspecified), null, (byte)0, null, null, "超级管理员", 1 });

            migrationBuilder.InsertData(
                table: "dt_user_roles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 3, 1 });

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_album_ArticleId",
                table: "dt_article_album",
                column: "ArticleId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_attach_ArticleId",
                table: "dt_article_attach",
                column: "ArticleId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_category_relation_ArticleId",
                table: "dt_article_category_relation",
                column: "ArticleId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_category_relation_CategoryId",
                table: "dt_article_category_relation",
                column: "CategoryId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_comment_ArticleId",
                table: "dt_article_comment",
                column: "ArticleId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_comment_UserId",
                table: "dt_article_comment",
                column: "UserId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_comment_like_CommentId",
                table: "dt_article_comment_like",
                column: "CommentId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_contribute_ChannelId",
                table: "dt_article_contribute",
                column: "ChannelId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_field_value_ArticleId",
                table: "dt_article_field_value",
                column: "ArticleId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_label_relation_ArticleId",
                table: "dt_article_label_relation",
                column: "ArticleId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_label_relation_LabelId",
                table: "dt_article_label_relation",
                column: "LabelId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_article_like_ArticleId",
                table: "dt_article_like",
                column: "ArticleId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_articles_ChannelId",
                table: "dt_articles",
                column: "ChannelId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_manager_UserId",
                table: "dt_manager",
                column: "UserId",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_dt_member_attach_log_AttachId",
                table: "dt_member_attach_log",
                column: "AttachId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_member_recharge_CollectionId",
                table: "dt_member_recharge",
                column: "CollectionId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_members_GroupId",
                table: "dt_members",
                column: "GroupId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_members_UserId",
                table: "dt_members",
                column: "UserId",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_dt_payment_collection_PaymentId",
                table: "dt_payment_collection",
                column: "PaymentId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_role_claims_RoleId",
                table: "dt_role_claims",
                column: "RoleId");

            migrationBuilder.CreateIndex(
                name: "RoleNameIndex",
                table: "dt_roles",
                column: "NormalizedName",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_dt_site_channel_SiteId",
                table: "dt_site_channel",
                column: "SiteId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_site_channel_field_ChannelId",
                table: "dt_site_channel_field",
                column: "ChannelId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_site_domain_SiteId",
                table: "dt_site_domain",
                column: "SiteId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_site_payment_PaymentId",
                table: "dt_site_payment",
                column: "PaymentId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_site_payment_SiteId",
                table: "dt_site_payment",
                column: "SiteId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_user_claims_UserId",
                table: "dt_user_claims",
                column: "UserId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_user_logins_UserId",
                table: "dt_user_logins",
                column: "UserId");

            migrationBuilder.CreateIndex(
                name: "IX_dt_user_roles_RoleId",
                table: "dt_user_roles",
                column: "RoleId");

            migrationBuilder.CreateIndex(
                name: "EmailIndex",
                table: "dt_users",
                column: "NormalizedEmail");

            migrationBuilder.CreateIndex(
                name: "UserNameIndex",
                table: "dt_users",
                column: "NormalizedUserName",
                unique: true);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "dt_areas");

            migrationBuilder.DropTable(
                name: "dt_article_album");

            migrationBuilder.DropTable(
                name: "dt_article_category_relation");

            migrationBuilder.DropTable(
                name: "dt_article_comment_like");

            migrationBuilder.DropTable(
                name: "dt_article_contribute");

            migrationBuilder.DropTable(
                name: "dt_article_field_value");

            migrationBuilder.DropTable(
                name: "dt_article_label_relation");

            migrationBuilder.DropTable(
                name: "dt_article_like");

            migrationBuilder.DropTable(
                name: "dt_manager");

            migrationBuilder.DropTable(
                name: "dt_manager_log");

            migrationBuilder.DropTable(
                name: "dt_manager_menu");

            migrationBuilder.DropTable(
                name: "dt_manager_menu_model");

            migrationBuilder.DropTable(
                name: "dt_member_address");

            migrationBuilder.DropTable(
                name: "dt_member_amount_log");

            migrationBuilder.DropTable(
                name: "dt_member_attach_log");

            migrationBuilder.DropTable(
                name: "dt_member_message");

            migrationBuilder.DropTable(
                name: "dt_member_point_log");

            migrationBuilder.DropTable(
                name: "dt_member_recharge");

            migrationBuilder.DropTable(
                name: "dt_members");

            migrationBuilder.DropTable(
                name: "dt_notify_template");

            migrationBuilder.DropTable(
                name: "dt_role_claims");

            migrationBuilder.DropTable(
                name: "dt_site_channel_field");

            migrationBuilder.DropTable(
                name: "dt_site_domain");

            migrationBuilder.DropTable(
                name: "dt_sysconfig");

            migrationBuilder.DropTable(
                name: "dt_user_claims");

            migrationBuilder.DropTable(
                name: "dt_user_logins");

            migrationBuilder.DropTable(
                name: "dt_user_roles");

            migrationBuilder.DropTable(
                name: "dt_user_tokens");

            migrationBuilder.DropTable(
                name: "dt_article_category");

            migrationBuilder.DropTable(
                name: "dt_article_comment");

            migrationBuilder.DropTable(
                name: "dt_article_label");

            migrationBuilder.DropTable(
                name: "dt_article_attach");

            migrationBuilder.DropTable(
                name: "dt_payment_collection");

            migrationBuilder.DropTable(
                name: "dt_member_group");

            migrationBuilder.DropTable(
                name: "dt_roles");

            migrationBuilder.DropTable(
                name: "dt_users");

            migrationBuilder.DropTable(
                name: "dt_articles");

            migrationBuilder.DropTable(
                name: "dt_site_payment");

            migrationBuilder.DropTable(
                name: "dt_site_channel");

            migrationBuilder.DropTable(
                name: "dt_payments");

            migrationBuilder.DropTable(
                name: "dt_sites");
        }
    }
}
